package com.njzxw.yoga.yogaApi.repository;

import com.njzxw.fs.commonutil.db.ZxwLangDriver;
import com.njzxw.yoga.yogaApi.bean.CityInfoBean;
import org.apache.ibatis.annotations.Lang;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface CityInfoRepository {

    @Select("select id, name, state, supperid supper_id, level from t_city_info a " +
            " where a.state = 1 " +
            "   and a.supperid = #{supper_id} " +
            "   and a.id = #{id}")
    @Lang(ZxwLangDriver.class)
    List<CityInfoBean> getCityList(CityInfoBean cityInfoBean);
}
